A DB2 Systems Programmer for z/OS Systems Programmer. with 5-10 Years experience.
• Self-motivated pro, capable of working independently or on a team, a strategic problem solver, and results-orientated.
• Capable of coordinating projects with technical teams in a high paced service oriented environment, and provide on-call support as required.
• Comfortable of handling high risk and high visibility situations with ease. Strong overall diagnostic and problem solving skills, and excellent verbal and written communication skills are required.
You Will:
• Monitor system storage, memory, I/O and CPU resources, design performance improvements.
• Evaluate and recommend innovative technological solutions to meet new/existing business requirements.
• Perform daily checklists, review daily Db2 reports for anomalies, open service now tickets to application groups for problem resolution.
• Provide timely resolution to DB2 software related problems. Work with the IBM and ISV vendor Level 2 and technical support teams to identify DB2 software related problems.
• Respond to S1 calls. Evaluate all components within DB2 for stability or errors. Drive problem source identification to root cause, provide workarounds, and design preventive measures.
• Create and maintain DB2 Systems SOPs and Runbooks according to the provided format.
• Participate in the planning and recovery of the DB2 subsystems as part of Disaster Recovery.
• Apply ServiceNow ticketing process for change control. Complete checklists for systems tasks and submit change controls for review in a timely manner.
• Manage DB2 Catalog/directory, WLM, bufferpools, zparms, PROCS, RLF, RTS. Build new subsystems or relocate existing ones upon request.
• Assist in the implementation of Data Studio + debugger.
• Provide technical expertise and guidance to the internal DB2 community.
• Contribute to the on-going development of monitoring and trending metrics for DB2 using Main View shipped SMF database.
• Manage DB2 reorgs, runstats, rebinds, PROCS, RTS, RLF, stored procedures.
• Participation in writing REXX for automation/autonomics for preventative, corrective, and predictive measures for outage avoidance.
• Performance tune tablespaces, partitions, indexes. Assist the application staff in preparing well-tuned SQL for the business. Understand the difference between Explain, and run-time access path determination.
• Diagnose performance issues, considering data distribution, cardinality, join structures, buffer pools, and data sharing members.
• Using SMPE, IBMLINK, and ShopZSeries, upgrade and apply maintenance to IBM products.
• Perform project planning and management of software upgrades & product implementation to supported DB2 environments. Install, support and customize licensed DB2 software and related tools (client & 3rd party vendors).
• Upgrade DB2 subsystem environments to newly released versions. Receive, apply and propagate software fixes across supported DB2 platforms, using SMP/E, etc.
• Coordinate maintenance and upgrades implementation with affected applications. Perform OEM problem analysis and resolution. Maintain OEM documentation.
• Create and maintain documentation in support of the DB2 environments. (E.g. Procedures, SOPs, Change Control, etc.). Implement advanced features/function of DB2 software (e.g. DB2 Data Sharing, native XML, etc.)
• Maintain DB2 at optimal maintenance levels, apply PTFs as needed. Coordinate maintenance and upgrades implementation with affected applications. Perform DB2 problem analysis and resolution
","jobTitle":"Mainframe DB2 Administrator","jobUpdatedDate":"2023-10-03T09:01:59.317Z","logo":"https://shenzyn-uploads.s3.ap-south-1.amazonaws.com/ProfilePics/itcshenzyn%40gmail.com_1519855878132.jfif","maxannualCTC":"1600000","minannualCTC":"1500000","otherMonetoryBenefits":"","travelRequired":false,"vacancies":"5","maxexperience":5,"minexperience":3,"noticePeriod":"30","jobPostApprovedDate":"2023-10-03T09:01:59.317Z","jobPostingApprovedBy":"itcshenzyn@gmail.com"}},"companyData":{"status":true,"message":"Company found","data":{"emailIdVerified":true,"womenCentricPolicies":["Childcare","Flexi-timing","Paternal Leaves","Fitness Initiatives","Work from Home","Additional Maternity Benefits"],"jobsPosted":["80461672","76715563","67803697","85275567","14212209","57686236","40049256","95954581","22557069","81628226","74933641","36238432","76721996","12149835","27348542","85754982","31019027","33675068","39141066","28781123","62914100","41331811","60064074","38086155","71955788"],"promotedJobs":false,"profileStatus":true,"accountStatus":true,"landingPagePublish":true,"testCompany":false,"profileCompletionPercentage":"100%","contractAttachedStatus":false,"permissions":[],"contract":[],"emailId":"itcshenzyn@gmail.com","username":"itcshenzyn@gmail.com","companyName":"ITC Technologies","logo":"https://shenzyn-uploads.s3.ap-south-1.amazonaws.com/ProfilePics/itcshenzyn%40gmail.com_1519855878132.jfif","coverPhoto":"https://shenzyn-uploads.s3.ap-south-1.amazonaws.com/Assets/defaultCoverPicture.png","cookieToken":"","remeberMe":null,"wrongPasswordCount":0,"address":" No.18, Gate No:1 & 2, Dodda Banaswadi Main Rd, Maruthi Sevanagar, Bengaluru, Karnataka 560005","contactNo":"08022988331","country":"India","countryCode":"+91","gstin":"29AAACI7376Q1ZO","industry":"business solutions & technology services","location":"Bengaluru , Karnataka","pincode":"560005","sacorhac":null,"website":"https://www.itcinfotech.com","aboutus":"ITC Infotech is a global technology solution and services leader providing business-friendly solutions, that enable future-readiness for clients. We seamlessly bring together digital expertise, strong industry specific alliances and deep domain expertise from ITC Group businesses.","additionalMaternityBenefits":null,"companyType":"Large","culture":"Our solutions and services are focused on Banking & Financial Services, Healthcare, Manufacturing, Consumer Goods, Travel and Hospitality.","employeeStrength":"10000","genderDiversity":null,"otherBenefits":null}},"recommendedJobs":[]}